Collect_Region.asp 云网互动影视系统(12套模版和资源联盟) 6.2 - ASP源码程序

www.gusucode.com > 云网互动影视系统(12套模版和资源联盟) 6.2 > 云网互动影视系统(12套模版和资源联盟) 6.2.4/免费版/Admin/Collect/Collect_Region.asp
    <html>
<head>
<META content=ywnt,云网互动影视管理系统 name=keywords>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>云网互动影视6.0--采集地区转换</title>
<LINK href="../css/css.css" type=text/css rel=stylesheet>
</head>
<BODY leftMargin=0 topMargin=0 scroll=yes MARGINHEIGHT="0" MARGINWIDTH="0">
<!--#include file="Conn.asp" -->
<!--#include file="../../Conn.asp" -->
<!--#include file="../YWNT_TMS_inc/YWNT_TMS_Function.asp" -->
<!--#include file="../YWNT_TMS_inc/YWNT_TMS_Page.asp" -->
<%
'===================================================================================================================
'软件名称：云网影视管理系统
'Copyright (C) 2002-2007 ywnt.net  All rights reserved.
'产品咨询QQ：489234,2813712
'程序版权：云网互动科技有限公司
'程序开发：云网互动科技有限公司
'官方网站：http://www.ywnt.net 
'郑重声明:
'    1、免费版本请在程序首页保留版权信息，并做上本站LOGO友情连接,商业版本无此要求;
'    2、任何个人或组织不得在授权允许的情况下删除、修改、拷贝本软件及其他副本上一切关于版权的信息；
'    3、云网互动科技有限公司保留此软件的法律追究权利
'===================================================================================================================
Call CheckLogin("Collect")
sub EditSave()
		Set Rs=Server.CreateObject(YWNT_TMS_RS)
		sql="select * from region where ID="&Request.Form("ID")
		Rs.open sql,Connx,1,3
		RS("Collectregion")=Request.Form("Collectregion")
		RS("regionID")=Request.Form("regionID")
		Rs.Update
		Rs.Close
		Set Rs = Nothing
		Call AddLog("修改采集地区转换",9)
		call Admin_ShowErr("<li>采集地区转换修改成功</li>","Collect_Region.asp",1)
end sub
sub AddSave()
		Set Rs=Server.CreateObject(YWNT_TMS_RS)
		sql="select * from region where Collectregion='"&Request.Form("Collectregione")&"'"
		Rs.open sql,Connx,1,3
		if Rs.eof then
		Rs.addnew
		RS("Collectregion")=Request.Form("Collectregion")
		RS("regionID")=Request.Form("regionID")
		Rs.Update
		Rs.Close
		Set Rs = Nothing
		Call AddLog("添加采集地区转换",9)
		call Admin_ShowErr("<li>采集地区转换添加成功</li>","Collect_Region.asp",1)
		else
		call Admin_ShowErr("<li>对不起已经有此转换地区</li>","Collect_Region.asp",0)
		end if
end sub
sub Del()
	Connx.execute "delete from region WHERE ID = "&Request("ID")&""
	Call AddLog("删除影片地区",3)
	call Admin_ShowErr("<li>影片地区删除成功！</li>","Collect_Region.asp",1)
end sub%>
<table class=table cellspacing=1 cellpadding=3 width="98%" align=center border=0>
    <tr>
      <td class=xingmu>采集地区转换管理</td>
    </tr>
    <tr>
      <td class="hback"><a href="Collect_Region.asp">采集地区转换管理首页</a> | <a href="Collect_Region.asp?Action=Add">添加采集地区转换</a> </td>
    </tr>
</table>
<% Action=Trim(request("Action"))
Select Case Action
Case "Add"
	call Add()
Case "AddSave"
	call AddSave()
Case "EditSave"
	call EditSave()
Case "Del"
	call Del()
Case else
	call List()
End Select
sub List()
Dim int_RPP
	int_RPP=GetConfig("PageNumber") '设置每页显示数目%>
<table class=table cellspacing=1 cellpadding=3 width="98%" align=center border=0>
    <tr>
      <td width="5%" align="center" class=xingmu>ID</td>
      <td width="40%" align="center" class=xingmu>取得地区</td>
      <td width="40%" align="center" class=xingmu>对应系统地区</td>
      <td width="15%" align="center" class=xingmu>操作</td>
    </tr>
	<%  Set Rs = server.CreateObject(YWNT_TMS_RS)
		sql="Select ID,Collectregion,regionID from region Order by id asc"
		Rs.open sql,Connx,1,1
	if Rs.eof then
	   Response.Write"<TR class=""hback""><TD colspan=""4"" class=""hback"" height=""40"">没有记录。</TD></TR>"
	else
		Rs.PageSize=int_RPP
		cPageNo=Request.QueryString("Page")
		If cPageNo="" Then cPageNo = 1
		If not isnumeric(cPageNo) Then cPageNo = 1
		cPageNo = Clng(cPageNo)
		If cPageNo>Rs.PageCount Then cPageNo=Rs.PageCount 
		If cPageNo<=0 Then cPageNo=1
		Rs.AbsolutePage=cPageNo 
	for i=1 to int_RPP
	 if Rs.eof Then exit For%> 
	 <form name="form<%=i%>" action="Collect_Region.asp?Action=EditSave" method="post">
    <tr>
      <td height=32 align="center" class="hback"><%= RS("ID") %></td>
      <td height=32 align="center" class="hback"><input name="Collectregion" type="text" id="Collectregion" value="<%= RS("Collectregion") %>" size="40"></td>
      <td height=32 align="center" class="hback"><%call MovieRegion("regionID",RS("regionID"))%>
      <input name="ID" type="hidden" value="<%= RS("ID") %>"></td>
      <td align="center" class="hback"><A href="javascript:form<%=i%>.submit();">修改</A>｜<A href="Collect_Region.asp?ID=<%= RS("ID") %>&Action=Del">删除</A></td>
    </tr>
	</form>
	<%Rs.MoveNext
	next
	end if%>
	<tr align="right">
	<td height=32 colspan="4" class="hback"><% response.Write fPageCount(Rs,cPageNo) %></td>
	</tr>
</table>
<%RS.Close
Set RS = Nothing
end sub
sub Add()%>
<table class=table cellspacing=1 cellpadding=3 width="98%" align=center border=0>
    <tr>
      <td colspan="4" class=xingmu>添加采集地区转换</td>
    </tr>
  <form name="form" action="Collect_Region.asp?Action=AddSave" method="post">
    <tr>
      <td width="15%" height=32 align="right" class="hback">取得地区：</td>
      <td width="35%" class="hback"><input name="Collectregion" type="text" id="Collectregion" size="40"></td>
      <td width="15%" align="right" class="hback">对应系统地区：</td>
      <td width="35%" class="hback"><%call MovieRegion("regionID","")%></td>
    </tr>
    <tr>
      <td height=32 colspan="4" align="center" class="hback"><input type="submit" name="Submit" value="添 加"></td>
    </tr>
  </form>
</table>
<%end sub
call Connclose()
call Connxclose()%>
</BODY>
</HTML>